SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_CheckEmployerAccountIsExist]
    (
      @JOL_Employer_Account VARCHAR(50)
    )
AS 
    SELECT  COUNT(JOL_Employer_Account)
    FROM    dbo.JOL_Employer
    WHERE   JOL_Employer_Account = @JOL_Employer_Account
GO
